use NorthWind
go

SELECT  RANK() OVER (order by city),City,*
FROM    Employees


SELECT  DENSE_RANK() OVER (order by city),City,*
FROM    Employees


SELECT  NTILE(3) OVER (order by city),City,*
FROM    Employees

